package com.hawthorn.redis.repository.provider;

import org.apache.ibatis.builder.annotation.ProviderMethodResolver;

/**
 * <p>todo 角色缓存sql类</p>
 * @author: andyten@tom.com | xukaixing@hotmail.com
 * @created: 2021/11/28 4:59 PM
 * @version v1.0.1
 * @copyright: Copyright (c)  andyten
 */
public class RoleCacheSqlProvider implements ProviderMethodResolver
{
  public static String selectRole()
  {
    String sql = "select  " +
        "id, " +
        "rcode, " +
        "rname, " +
        "ename, " +
        "dept_id, " +
        "level, " +
        "type " +
        "from sys_role " +
        "where del_flag = 0 " +
        // " and status = " + DicConstant.YXBS_01 +
        " order by rcode";
    return sql;
  }
}
